﻿CREATE TABLE [dbo].[PearlAccountMap] (
    [Id]             INT           IDENTITY (1, 1) NOT NULL,
    [AccountL14Desc] VARCHAR (150) NOT NULL,
    [Leaf]           VARCHAR (15)  NOT NULL,
    [LeafDescr]      VARCHAR (256) NOT NULL,
    [LineType]       VARCHAR (50)  NOT NULL,
    [AditionalRule]  VARCHAR (100) NULL,
    [NoReconcilable] BIT           DEFAULT ('0') NOT NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

